Oracle Performance Tuning for 10gR2, 2/e
內容描述
Description
Tuning of SQL code is generally cheaper than
changing the data model. Physical and configuration tuning involves a search
for bottlenecks that often points to SQL code or data model issues. Building
an appropriate data model and writing properly performing SQL code can give
100%+ performance improvement. Physical and configuration tuning often gives
at most a 25% performance increase. Gavin Powell shows that the central theme
of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit
applications; tune SQL code according to both the data model and the
application in relation to scalability; create a well-proportioned physical
architecture at the time of initial Oracle installation; and most important,
mix skill sets to obtain the best results.
Table
of Contents
Introduction Part 1: Security
Standards and Compliance Part 2: HP NonStop server Subsystems Chapter 1:
Safeguard Subsystem Updates Chapter 2: TCP/IP Subsystem Chapter 3: TSM/OSM
Subsystem Chapter 4: DSM/SCM Subsystem Chapter 5: The Open System Services
(OSS) Chapter 6: ODBC Chapter 7: SQL/MX Part 3: The Guardian Gazette A – Z
Part 4: The OSS Gazette Appendices Appendix A: Gathering The Audit Information
Appendix B: Tandem File Codes Appendix C: Third Party HP NonStop Server
Security